package LawsonTransformJava.data;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

public class TblPAEmergCnt {
	
	public int company 		= 0;
	public int employee		= 0;
	public int seq_nbr		= 0;
	public String last_name 	= null;
	public String first_name	= null;
	public String middle_init	= null;
	public String addr1		= null;
	public String addr2		= null;
	public String addr3		= null;
	public String addr4		= null;
	public String city		= null;
	public String state		= null;
	public String zip		= null;
	public String relationship	= null;
	public String hm_phone_cntry	= null;
	public String hm_phone_nbr	= null;
	public String wk_phone_cntry	= null;
	public String wk_phone_nbr	= null;
	public String wk_phone_ext	= null;
	public String country_code	= null;
	public Date   date_stamp	= null;
	public int    time_stamp	= 0;
	public String user_id		= null;
	public String l_index		= null;
	public String l_atpae_ss_sw	= null;
	public String cl_phone_cntry	= null;
	public String cl_phone_nbr	= null;
	
	private DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
	private DateFormat df2 = new SimpleDateFormat("yyyyMMdd");	
	private String text; 
	
	public void setCompany(int company) {
		this.company = company;
	}
	public void setEmployee(int employee) {
		this.employee = employee;
	}
	public void setSeq_nbr(int seq_nbr) {
		this.seq_nbr = seq_nbr;
	}
	public void setLast_name(String last_name) {
		this.last_name = last_name;
	}
	public void setFirst_name(String first_name) {
		this.first_name = first_name;
	}
	public void setMiddle_init(String middle_init) {
		this.middle_init = middle_init;
	}
	public void setAddr1(String addr1) {
		this.addr1 = addr1;
	}
	public void setAddr2(String addr2) {
		this.addr2 = addr2;
	}
	public void setAddr3(String addr3) {
		this.addr3 = addr3;
	}
	public void setAddr4(String addr4) {
		this.addr4 = addr4;
	}
	public void setCity(String city) {
		this.city = city;
	}
	public void setState(String state) {
		this.state = state;
	}
	public void setZip(String zip) {
		this.zip = zip;
	}
	public void setRelationship(String relationship) {
		this.relationship = relationship;
	}
	public void setHm_phone_cntry(String hm_phone_cntry) {
		this.hm_phone_cntry = hm_phone_cntry;
	}
	public void setHm_phone_nbr(String hm_phone_nbr) {
		this.hm_phone_nbr = hm_phone_nbr;
	}
	public void setWk_phone_cntry(String wk_phone_cntry) {
		this.wk_phone_cntry = wk_phone_cntry;
	}
	public void setWk_phone_nbr(String wk_phone_nbr) {
		this.wk_phone_nbr = wk_phone_nbr;
	}
	public void setWk_phone_ext(String wk_phone_ext) {
		this.wk_phone_ext = wk_phone_ext;
	}
	public void setCountry_code(String country_code) {
		this.country_code = country_code;
	}
	public void setDate_stamp(Date date_stamp) {
		this.date_stamp = date_stamp;
	}
	public void setTime_stamp(int time_stamp) {
		this.time_stamp = time_stamp;
	}
	public void setUser_id(String user_id) {
		this.user_id = user_id;
	}
	public void setL_index(String l_index) {
		this.l_index = l_index;
	}
	public void setL_atpae_ss_sw(String l_atpae_ss_sw) {
		this.l_atpae_ss_sw = l_atpae_ss_sw;
	}
	public void setCl_phone_cntry(String cl_phone_cntry) {
		this.cl_phone_cntry = cl_phone_cntry;
	}
	public void setCl_phone_nbr(String cl_phone_nbr) {
		this.cl_phone_nbr = cl_phone_nbr;
	}
	
	
	public int getCompany() {
		return company;
	}
	public int getEmployee() {
		return employee;
	}
	public int getSeq_nbr() {
		return seq_nbr;
	}
	public String getLast_name() {
		if (last_name==null||last_name.equals(""))
		{text = "";}
	else
		{text = "\""+last_name+"\"";}
	return text;		
	}
	public String getFirst_name() {
		if (first_name==null||first_name.equals(""))
		{text = "";}
	else
		{text = "\""+first_name+"\"";}
	return text;		
	}
	public String getMiddle_init() {
		if (middle_init==null||middle_init.equals(""))
		{text = "";}
	else
		{text = "\""+middle_init+"\"";}
	return text;		
	}
	public String getAddr1() {
		if (addr1==null||addr1.equals(""))
		{text = "";}
	else
		{text = "\""+addr1+"\"";}
	return text;
	}
	public String getAddr2() {
		if (addr2==null||addr2.equals(""))
		{text = "";}
	else
		{text = "\""+addr2+"\"";}
	return text;
	}
	public String getAddr3() {
		if (addr3==null||addr3.equals(""))
		{text = "";}
	else
		{text = "\""+addr3+"\"";}
	return text;
	}
	public String getAddr4() {
		if (addr4==null||addr4.equals(""))
		{text = "";}
	else
		{text = "\""+addr4+"\"";}
	return text;
	}
	public String getCity() {
		if (city==null||city.equals(""))
		{text = "";}
	else
		{text = "\""+city+"\"";}
	return text;
	}
	public String getState() {
		if (state==null||state.equals(""))
		{text = "";}
	else
		{text = "\""+state+"\"";}
	return text;		
	}
	public String getZip() {
		if (zip==null||zip.equals(""))
		{text = "";}
	else
		{text = "\""+zip+"\"";}
	return text;
	}
	public String getRelationship() {
		if (relationship==null||relationship.equals(""))
		{text = "";}
	else
		{text = "\""+relationship+"\"";}
	return text;		
	}
	public String getHm_phone_cntry() {
		if (hm_phone_cntry==null||hm_phone_cntry.equals(""))
		{text = "";}
	else
		{text = "\""+hm_phone_cntry+"\"";}
	return text;		
	}
	public String getHm_phone_nbr() {
		if (hm_phone_nbr==null||hm_phone_nbr.equals(""))
		{text = "";}
	else
		{text = "\""+hm_phone_nbr+"\"";}
	return text;		
	}
	public String getWk_phone_cntry() {
		if (wk_phone_cntry==null||wk_phone_cntry.equals(""))
		{text = "";}
	else
		{text = "\""+wk_phone_cntry+"\"";}
	return text;		
	}
	public String getWk_phone_nbr() {
		if (wk_phone_nbr==null||wk_phone_nbr.equals(""))
		{text = "";}
	else
		{text = "\""+wk_phone_nbr+"\"";}
	return text;		
	}
	public String getWk_phone_ext() {
		if (wk_phone_ext==null||wk_phone_ext.equals(""))
		{text = "";}
	else
		{text = "\""+wk_phone_ext+"\"";}
	return text;		
	}
	public String getCountry_code() {
		if (country_code==null||country_code.equals(""))
		{text = "";}
	else
		{text = "\""+country_code+"\"";}
	return text;		
	}
	public String getDate_stamp() {
		if (date_stamp==null)
			{text = "";}
		else
			{String date =(date_stamp!=null?df2.format(date_stamp).toString():""); 
			if (date.equals("17000101"))
				{text = "";}
			else
				{text ="\"" + df.format(date_stamp).toString() + "\"";;}}
		return text;		
	
	}
	public int getTime_stamp() {
		return time_stamp;
	}
	public String getUser_id() {
		if (user_id==null||user_id.equals(""))
		{text = "";}
	else
		{text = "\""+user_id+"\"";}
	return text;		
	}
	public String getL_index() {
		if (l_index==null||l_index.equals(""))
		{text = "";}
	else
		{text = "\""+l_index+"\"";}
	return text;		
	}
	public String getL_atpae_ss_sw() {
		if (l_atpae_ss_sw==null||l_atpae_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+l_atpae_ss_sw+"\"";}
	return text;		
	}
	public String getCl_phone_cntry() {
		if (cl_phone_cntry==null||cl_phone_cntry.equals(""))
		{text = "";}
	else
		{text = "\""+cl_phone_cntry+"\"";}
	return text;
	}
	public String getCl_phone_nbr() {
		if (cl_phone_nbr==null||cl_phone_nbr.equals(""))
		{text = "";}
	else
		{text = "\""+cl_phone_nbr+"\"";}
	return text;		
	}
	
	
}

